Pandas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	55381
Missing cells	206603
Missing cells (%)	17.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.3 MiB
Average record size in memory	176.0 B

Variable types

Categorical	10
Numeric	8
Boolean	1
Unsupported	3

Alerts

`socialEngagementType` has constant value "Not Socially Engaged"	Constant
`totals.newVisits` has constant value "1.0"	Constant
`trafficSource.isTrueDirect` has constant value "True"	Constant
`totals.bounces` has constant value "1.0"	Constant
`geoNetwork.country` has a high cardinality: 173 distinct values	High cardinality
`trafficSource.source` has a high cardinality: 108 distinct values	High cardinality
`totals.hits` is highly correlated with `totals.pageviews` and 1 other fields	High correlation
`totals.pageviews` is highly correlated with `totals.hits` and 1 other fields	High correlation
`totals.timeOnSite` is highly correlated with `totals.hits` and 1 other fields	High correlation
`totals.hits` is highly correlated with `totals.pageviews` and 1 other fields	High correlation
`totals.pageviews` is highly correlated with `totals.hits` and 1 other fields	High correlation
`totals.timeOnSite` is highly correlated with `totals.hits` and 1 other fields	High correlation
`totals.hits` is highly correlated with `totals.pageviews` and 1 other fields	High correlation
`totals.pageviews` is highly correlated with `totals.hits` and 1 other fields	High correlation
`totals.timeOnSite` is highly correlated with `totals.hits` and 1 other fields	High correlation
`socialEngagementType` is highly correlated with `device.deviceCategory` and 7 other fields	High correlation
`device.deviceCategory` is highly correlated with `socialEngagementType` and 4 other fields	High correlation
`totals.newVisits` is highly correlated with `socialEngagementType` and 7 other fields	High correlation
`trafficSource.isTrueDirect` is highly correlated with `socialEngagementType` and 7 other fields	High correlation
`trafficSource.medium` is highly correlated with `socialEngagementType` and 4 other fields	High correlation
`device.browser` is highly correlated with `socialEngagementType` and 4 other fields	High correlation
`totals.bounces` is highly correlated with `socialEngagementType` and 7 other fields	High correlation
`channelGrouping` is highly correlated with `socialEngagementType` and 4 other fields	High correlation
`device.operatingSystem` is highly correlated with `socialEngagementType` and 5 other fields	High correlation
`channelGrouping` is highly correlated with `trafficSource.medium`	High correlation
`totals.hits` is highly correlated with `totals.pageviews` and 1 other fields	High correlation
`totals.pageviews` is highly correlated with `totals.hits` and 3 other fields	High correlation
`totals.timeOnSite` is highly correlated with `totals.hits` and 2 other fields	High correlation
`totals.transactions` is highly correlated with `totals.pageviews` and 1 other fields	High correlation
`totals.totalTransactionRevenue` is highly correlated with `totals.pageviews` and 2 other fields	High correlation
`trafficSource.medium` is highly correlated with `channelGrouping`	High correlation
`device.browser` is highly correlated with `device.operatingSystem`	High correlation
`device.operatingSystem` is highly correlated with `device.browser` and 1 other fields	High correlation
`device.deviceCategory` is highly correlated with `device.operatingSystem`	High correlation
`totals.timeOnSite` has 24783 (44.8%) missing values	Missing
`totals.transactions` has 49516 (89.4%) missing values	Missing
`totals.newVisits` has 13705 (24.7%) missing values	Missing
`totals.totalTransactionRevenue` has 49520 (89.4%) missing values	Missing
`trafficSource.isTrueDirect` has 38404 (69.3%) missing values	Missing
`totals.bounces` has 30667 (55.4%) missing values	Missing
`hits.type` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`hits.hour` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`hits.minute` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`hits.eCommerceAction.action_type` has 55010 (99.3%) zeros	Zeros

Reproduction

Analysis started	2022-05-13 02:15:04.986521
Analysis finished	2022-05-13 02:15:35.505816
Duration	30.52 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

socialEngagementType
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

Not Socially Engaged	55381

Length

Max length	20
Median length	20
Mean length	20
Min length	20

Characters and Unicode

Total characters	1107620
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Socially Engaged
2nd row	Not Socially Engaged
3rd row	Not Socially Engaged
4th row	Not Socially Engaged
5th row	Not Socially Engaged

Common Values

Value	Count	Frequency (%)
Not Socially Engaged	55381	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
not	55381	33.3%
socially	55381	33.3%
engaged	55381	33.3%

Most occurring characters

Value	Count	Frequency (%)
o	110762	10.0%
	110762	10.0%
a	110762	10.0%
l	110762	10.0%
g	110762	10.0%
N	55381	5.0%
t	55381	5.0%
S	55381	5.0%
c	55381	5.0%
i	55381	5.0%
Other values (5)	276905	25.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	830715	75.0%
Uppercase Letter	166143	15.0%
Space Separator	110762	10.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	110762	13.3%
a	110762	13.3%
l	110762	13.3%
g	110762	13.3%
t	55381	6.7%
c	55381	6.7%
i	55381	6.7%
y	55381	6.7%
n	55381	6.7%
e	55381	6.7%

Uppercase Letter

Value	Count	Frequency (%)
N	55381	33.3%
S	55381	33.3%
E	55381	33.3%

Space Separator

Value	Count	Frequency (%)
	110762	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	996858	90.0%
Common	110762	10.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	110762	11.1%
a	110762	11.1%
l	110762	11.1%
g	110762	11.1%
N	55381	5.6%
t	55381	5.6%
S	55381	5.6%
c	55381	5.6%
i	55381	5.6%
y	55381	5.6%
Other values (4)	221524	22.2%

Common

Value	Count	Frequency (%)
	110762	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1107620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	110762	10.0%
	110762	10.0%
a	110762	10.0%
l	110762	10.0%
g	110762	10.0%
N	55381	5.0%
t	55381	5.0%
S	55381	5.0%
c	55381	5.0%
i	55381	5.0%
Other values (5)	276905	25.0%

channelGrouping
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

Organic Search	19245
Social	17636
Direct	7918
Referral	7833
Paid Search	1562
Other values (2)	1187

Length

Max length	14
Median length	11
Mean length	9.267709142
Min length	6

Characters and Unicode

Total characters	513255
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Organic Search
2nd row	Organic Search
3rd row	Organic Search
4th row	Organic Search
5th row	Organic Search

Common Values

Value	Count	Frequency (%)
Organic Search	19245	34.8%
Social	17636	31.8%
Direct	7918	14.3%
Referral	7833	14.1%
Paid Search	1562	2.8%
Affiliates	782	1.4%
Display	405	0.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
search	20807	27.3%
organic	19245	25.3%
social	17636	23.1%
direct	7918	10.4%
referral	7833	10.3%
paid	1562	2.1%
affiliates	782	1.0%
display	405	0.5%

Most occurring characters

Value	Count	Frequency (%)
a	68270	13.3%
c	65606	12.8%
r	63636	12.4%
i	48330	9.4%
e	45173	8.8%
S	38443	7.5%
l	26656	5.2%
	20807	4.1%
h	20807	4.1%
O	19245	3.7%
Other values (13)	96282	18.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	416260	81.1%
Uppercase Letter	76188	14.8%
Space Separator	20807	4.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	68270	16.4%
c	65606	15.8%
r	63636	15.3%
i	48330	11.6%
e	45173	10.9%
l	26656	6.4%
h	20807	5.0%
g	19245	4.6%
n	19245	4.6%
o	17636	4.2%
Other values (6)	21656	5.2%

Uppercase Letter

Value	Count	Frequency (%)
S	38443	50.5%
O	19245	25.3%
D	8323	10.9%
R	7833	10.3%
P	1562	2.1%
A	782	1.0%

Space Separator

Value	Count	Frequency (%)
	20807	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	492448	95.9%
Common	20807	4.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	68270	13.9%
c	65606	13.3%
r	63636	12.9%
i	48330	9.8%
e	45173	9.2%
S	38443	7.8%
l	26656	5.4%
h	20807	4.2%
O	19245	3.9%
g	19245	3.9%
Other values (12)	77037	15.6%

Common

Value	Count	Frequency (%)
	20807	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	513255	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	68270	13.3%
c	65606	12.8%
r	63636	12.4%
i	48330	9.4%
e	45173	8.8%
S	38443	7.5%
l	26656	5.2%
	20807	4.1%
h	20807	4.1%
O	19245	3.7%
Other values (13)	96282	18.8%

date
Real number (ℝ_≥0)

Distinct	184
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20162192.01

Minimum	20160801
Maximum	20170131
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.8 KiB

Quantile statistics

Minimum	20160801
5-th percentile	20160811
Q1	20160921
median	20161102
Q3	20161206
95-th percentile	20170120
Maximum	20170131
Range	9330
Interquartile range (IQR)	285

Descriptive statistics

Standard deviation	3040.550087
Coefficient of variation (CV)	0.0001508045398
Kurtosis	2.9326919
Mean	20162192.01
Median Absolute Deviation (MAD)	112
Skewness	2.217409118
Sum	1.116602356 × 10¹²
Variance	9244944.834
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20161128	547	1.0%
20161115	525	0.9%
20161004	497	0.9%
20161201	479	0.9%
20161205	478	0.9%
20161129	470	0.8%
20161026	469	0.8%
20161116	466	0.8%
20161114	464	0.8%
20161130	457	0.8%
Other values (174)	50529	91.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20160801	208	0.4%
20160802	245	0.4%
20160803	327	0.6%
20160804	342	0.6%
20160805	322	0.6%
20160806	185	0.3%
20160807	183	0.3%
20160808	290	0.5%
20160809	298	0.5%
20160810	308	0.6%

Value	Count	Frequency (%)
20170131	237	0.4%
20170130	264	0.5%
20170129	194	0.4%
20170128	155	0.3%
20170127	224	0.4%
20170126	233	0.4%
20170125	352	0.6%
20170124	413	0.7%
20170123	236	0.4%
20170122	178	0.3%

fullVisitorId
Real number (ℝ_≥0)

Distinct	51510
Distinct (%)	93.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.517018685 × 10¹⁸

Minimum	3.579413597 × 10¹³
Maximum	9.999357271 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.8 KiB

Quantile statistics

Minimum	3.579413597 × 10¹³
5-th percentile	2.153310022 × 10¹⁷
Q1	1.649316738 × 10¹⁸
median	4.398696916 × 10¹⁸
Q3	7.19973052 × 10¹⁸
95-th percentile	9.450484153 × 10¹⁸
Maximum	9.999357271 × 10¹⁸
Range	9.999321477 × 10¹⁸
Interquartile range (IQR)	5.550413782 × 10¹⁸

Descriptive statistics

Standard deviation	3.060419211 × 10¹⁸
Coefficient of variation (CV)	0.6775307841
Kurtosis	-1.274019915
Mean	4.517018685 × 10¹⁸
Median Absolute Deviation (MAD)	2.772709824 × 10¹⁸
Skewness	0.1307247016
Sum	2.501570118 × 10²³
Variance	9.366165748 × 10³⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.856749148 × 10¹⁸	21	< 0.1%
3.608475193 × 10¹⁸	20	< 0.1%
6.760732402 × 10¹⁸	18	< 0.1%
8.248397261 × 10¹⁷	16	< 0.1%
9.497189156 × 10¹⁷	15	< 0.1%
1.957458976 × 10¹⁸	15	< 0.1%
4.578640586 × 10¹⁸	15	< 0.1%
1.063651652 × 10¹⁸	13	< 0.1%
6.254908847 × 10¹⁸	12	< 0.1%
1.956307608 × 10¹⁸	11	< 0.1%
Other values (51500)	55225	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.579413597 × 10¹³	1	< 0.1%
1.52474579 × 10¹⁴	1	< 0.1%
1.664652655 × 10¹⁴	1	< 0.1%
2.037409535 × 10¹⁴	1	< 0.1%
2.215385223 × 10¹⁴	1	< 0.1%
3.033655489 × 10¹⁴	1	< 0.1%
3.488329061 × 10¹⁴	1	< 0.1%
4.353240613 × 10¹⁴	1	< 0.1%
4.923040577 × 10¹⁴	1	< 0.1%
5.050029954 × 10¹⁴	1	< 0.1%

Value	Count	Frequency (%)
9.999357271 × 10¹⁸	1	< 0.1%
9.998996003 × 10¹⁸	1	< 0.1%
9.998663691 × 10¹⁸	1	< 0.1%
9.998628427 × 10¹⁸	1	< 0.1%
9.998597322 × 10¹⁸	1	< 0.1%
9.998297178 × 10¹⁸	1	< 0.1%
9.998185327 × 10¹⁸	1	< 0.1%
9.998113232 × 10¹⁸	1	< 0.1%
9.997950947 × 10¹⁸	1	< 0.1%
9.997801738 × 10¹⁸	1	< 0.1%

totals.hits
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	211
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.152904426

Minimum	1
Maximum	500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	7
95-th percentile	39
Maximum	500
Range	499
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	17.75991486
Coefficient of variation (CV)	2.178354355
Kurtosis	97.11865055
Mean	8.152904426
Median Absolute Deviation (MAD)	1
Skewness	6.898052433
Sum	451516
Variance	315.4145758
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	24516	44.3%
2	8220	14.8%
3	3532	6.4%
4	2252	4.1%
5	1679	3.0%
6	1312	2.4%
7	1081	2.0%
8	887	1.6%
9	779	1.4%
10	658	1.2%
Other values (201)	10465	18.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	24516	44.3%
2	8220	14.8%
3	3532	6.4%
4	2252	4.1%
5	1679	3.0%
6	1312	2.4%
7	1081	2.0%
8	887	1.6%
9	779	1.4%
10	658	1.2%

Value	Count	Frequency (%)
500	3	< 0.1%
471	1	< 0.1%
406	1	< 0.1%
387	1	< 0.1%
385	1	< 0.1%
382	1	< 0.1%
378	1	< 0.1%
361	1	< 0.1%
347	1	< 0.1%
331	1	< 0.1%

totals.pageviews
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	156
Distinct (%)	0.3%
Missing	8
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	6.548353891

Minimum	1
Maximum	469
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	6
95-th percentile	30
Maximum	469
Range	468
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	13.01594648
Coefficient of variation (CV)	1.987666931
Kurtosis	114.3956568
Mean	6.548353891
Median Absolute Deviation (MAD)	1
Skewness	6.921747415
Sum	362602
Variance	169.4148628
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	24850	44.9%
2	8607	15.5%
3	3732	6.7%
4	2374	4.3%
5	1828	3.3%
6	1298	2.3%
7	1118	2.0%
8	888	1.6%
9	794	1.4%
10	696	1.3%
Other values (146)	9188	16.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	24850	44.9%
2	8607	15.5%
3	3732	6.7%
4	2374	4.3%
5	1828	3.3%
6	1298	2.3%
7	1118	2.0%
8	888	1.6%
9	794	1.4%
10	696	1.3%

Value	Count	Frequency (%)
469	1	< 0.1%
431	1	< 0.1%
351	1	< 0.1%
341	1	< 0.1%
323	1	< 0.1%
309	1	< 0.1%
305	1	< 0.1%
270	1	< 0.1%
233	1	< 0.1%
232	1	< 0.1%

totals.timeOnSite
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	2694
Distinct (%)	8.8%
Missing	24783
Missing (%)	44.8%
Infinite	0
Infinite (%)	0.0%
Mean	392.2494281

Minimum	1
Maximum	15047
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.8 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	44
median	114
Q3	459
95-th percentile	1706.15
Maximum	15047
Range	15046
Interquartile range (IQR)	415

Descriptive statistics

Standard deviation	673.3060416
Coefficient of variation (CV)	1.716525235
Kurtosis	38.08969347
Mean	392.2494281
Median Absolute Deviation (MAD)	99
Skewness	4.336266284
Sum	12002048
Variance	453341.0256
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51	465	0.8%
5	440	0.8%
4	436	0.8%
50	382	0.7%
6	381	0.7%
52	380	0.7%
7	290	0.5%
9	276	0.5%
54	274	0.5%
53	272	0.5%
Other values (2684)	27002	48.8%
(Missing)	24783	44.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	35	0.1%
2	62	0.1%
3	200	0.4%
4	436	0.8%
5	440	0.8%
6	381	0.7%
7	290	0.5%
8	252	0.5%
9	276	0.5%
10	213	0.4%

Value	Count	Frequency (%)
15047	1	< 0.1%
14279	1	< 0.1%
12466	1	< 0.1%
11094	1	< 0.1%
10076	1	< 0.1%
10046	1	< 0.1%
9275	1	< 0.1%
8999	1	< 0.1%
8811	1	< 0.1%
8805	1	< 0.1%

totals.transactions
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	7
Distinct (%)	0.1%
Missing	49516
Missing (%)	89.4%
Infinite	0
Infinite (%)	0.0%
Mean	1.047740835

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	8
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3253271431
Coefficient of variation (CV)	0.310503449
Kurtosis	158.2772429
Mean	1.047740835
Median Absolute Deviation (MAD)	0
Skewness	10.96153301
Sum	6145
Variance	0.10583775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	5671	10.2%
2	155	0.3%
3	19	< 0.1%
5	9	< 0.1%
6	5	< 0.1%
4	4	< 0.1%
8	2	< 0.1%
(Missing)	49516	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5671	10.2%
2	155	0.3%
3	19	< 0.1%
4	4	< 0.1%
5	9	< 0.1%
6	5	< 0.1%
8	2	< 0.1%

Value	Count	Frequency (%)
8	2	< 0.1%
6	5	< 0.1%
5	9	< 0.1%
4	4	< 0.1%
3	19	< 0.1%
2	155	0.3%
1	5671	10.2%

totals.newVisits
Categorical

CONSTANT
HIGH CORRELATION
MISSING
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	13705
Missing (%)	24.7%
Memory size	432.8 KiB

1.0	41676

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	125028
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	41676	75.3%
(Missing)	13705	24.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
1.0	41676	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	41676	33.3%
.	41676	33.3%
0	41676	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	83352	66.7%
Other Punctuation	41676	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	41676	50.0%
0	41676	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	41676	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	125028	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	41676	33.3%
.	41676	33.3%
0	41676	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	125028	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	41676	33.3%
.	41676	33.3%
0	41676	33.3%

totals.totalTransactionRevenue
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	3688
Distinct (%)	62.9%
Missing	49520
Missing (%)	89.4%
Infinite	0
Infinite (%)	0.0%
Mean	146301015.2

Minimum	1200000
Maximum	1.603275 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.8 KiB

Quantile statistics

Minimum	1200000
5-th percentile	15590000
Q1	30960000
median	58460000
Q3	121740000
95-th percentile	557000000
Maximum	1.603275 × 10¹⁰
Range	1.603155 × 10¹⁰
Interquartile range (IQR)	90780000

Descriptive statistics

Standard deviation	386609149.2
Coefficient of variation (CV)	2.642559579
Kurtosis	586.1038572
Mean	146301015.2
Median Absolute Deviation (MAD)	33490000
Skewness	18.28000083
Sum	8.5747025 × 10¹¹
Variance	1.494666342 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24990000	56	0.1%
23990000	53	0.1%
19990000	43	0.1%
25990000	42	0.1%
21990000	38	0.1%
22990000	36	0.1%
20990000	33	0.1%
18990000	33	0.1%
17990000	28	0.1%
26990000	26	< 0.1%
Other values (3678)	5473	9.9%
(Missing)	49520	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1200000	1	< 0.1%
2040000	1	< 0.1%
2490000	1	< 0.1%
2990000	3	< 0.1%
3010000	1	< 0.1%
3160000	1	< 0.1%
3200000	2	< 0.1%
3400000	1	< 0.1%
3500000	1	< 0.1%
3530000	1	< 0.1%

Value	Count	Frequency (%)
1.603275 × 10¹⁰	1	< 0.1%
9227740000	1	< 0.1%
7003500000	1	< 0.1%
6239580000	1	< 0.1%
5945580000	1	< 0.1%
4849600000	1	< 0.1%
4087500000	1	< 0.1%
4013080000	1	< 0.1%
3394800000	1	< 0.1%
3013640000	1	< 0.1%

geoNetwork.country
Categorical

HIGH CARDINALITY

Distinct	173
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

United States	23746
India	2526
Vietnam	2219
United Kingdom	1742
Turkey	1730
Other values (168)	23418

Length

Max length	22
Median length	20
Mean length	9.837417165
Min length	4

Characters and Unicode

Total characters	544806
Distinct characters	60
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15 ?
Unique (%)	< 0.1%

Sample

1st row	Belarus
2nd row	Greece
3rd row	Ireland
4th row	Indonesia
5th row	Australia

Common Values

Value	Count	Frequency (%)
United States	23746	42.9%
India	2526	4.6%
Vietnam	2219	4.0%
United Kingdom	1742	3.1%
Turkey	1730	3.1%
Thailand	1671	3.0%
Brazil	1412	2.5%
Canada	1406	2.5%
Japan	1007	1.8%
Mexico	950	1.7%
Other values (163)	16972	30.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
united	25701	31.0%
states	23746	28.6%
india	2526	3.0%
vietnam	2219	2.7%
kingdom	1742	2.1%
turkey	1730	2.1%
thailand	1671	2.0%
brazil	1412	1.7%
canada	1406	1.7%
japan	1007	1.2%
Other values (189)	19735	23.8%

Most occurring characters

Value	Count	Frequency (%)
t	79540	14.6%
e	65176	12.0%
a	58756	10.8%
n	47905	8.8%
i	47461	8.7%
d	36536	6.7%
s	29552	5.4%
	27514	5.1%
S	26126	4.8%
U	26099	4.8%
Other values (50)	100141	18.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	433940	79.7%
Uppercase Letter	82878	15.2%
Space Separator	27514	5.1%
Open Punctuation	185	< 0.1%
Close Punctuation	185	< 0.1%
Other Punctuation	79	< 0.1%
Final Punctuation	19	< 0.1%
Dash Punctuation	6	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	79540	18.3%
e	65176	15.0%
a	58756	13.5%
n	47905	11.0%
i	47461	10.9%
d	36536	8.4%
s	29552	6.8%
r	11727	2.7%
l	9246	2.1%
o	8330	1.9%
Other values (19)	39711	9.2%

Uppercase Letter

Value	Count	Frequency (%)
S	26126	31.5%
U	26099	31.5%
I	4423	5.3%
T	4155	5.0%
K	2484	3.0%
V	2384	2.9%
C	2328	2.8%
B	2074	2.5%
P	2059	2.5%
A	1841	2.2%
Other values (14)	8905	10.7%

Other Punctuation

Value	Count	Frequency (%)
&	74	93.7%
.	5	6.3%

Space Separator

Value	Count	Frequency (%)
	27514	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	185	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	185	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	19	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	516818	94.9%
Common	27988	5.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	79540	15.4%
e	65176	12.6%
a	58756	11.4%
n	47905	9.3%
i	47461	9.2%
d	36536	7.1%
s	29552	5.7%
S	26126	5.1%
U	26099	5.0%
r	11727	2.3%
Other values (43)	87940	17.0%

Common

Value	Count	Frequency (%)
	27514	98.3%
(	185	0.7%
)	185	0.7%
&	74	0.3%
’	19	0.1%
-	6	< 0.1%
.	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	544754	> 99.9%
None	33	< 0.1%
Punctuation	19	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	79540	14.6%
e	65176	12.0%
a	58756	10.8%
n	47905	8.8%
i	47461	8.7%
d	36536	6.7%
s	29552	5.4%
	27514	5.1%
S	26126	4.8%
U	26099	4.8%
Other values (46)	100089	18.4%

None

Value	Count	Frequency (%)
ô	19	57.6%
é	12	36.4%
ç	2	6.1%

Punctuation

Value	Count	Frequency (%)
’	19	100.0%

trafficSource.source
Categorical

HIGH CARDINALITY

Distinct	108
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

(direct)	27422
youtube.com	17170
google	7047
Partners	782
analytics.google.com	575
Other values (103)	2385

Length

Max length	31
Median length	8
Mean length	8.914790271
Min length	3

Characters and Unicode

Total characters	493710
Distinct characters	35
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	33 ?
Unique (%)	0.1%

Sample

1st row	google
2nd row	google
3rd row	google
4th row	google
5th row	google

Common Values

Value	Count	Frequency (%)
(direct)	27422	49.5%
youtube.com	17170	31.0%
google	7047	12.7%
Partners	782	1.4%
analytics.google.com	575	1.0%
dfa	405	0.7%
sites.google.com	236	0.4%
baidu	235	0.4%
google.com	199	0.4%
siliconvalley.about.com	151	0.3%
Other values (98)	1159	2.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
direct	27422	49.5%
youtube.com	17170	31.0%
google	7047	12.7%
partners	782	1.4%
analytics.google.com	575	1.0%
dfa	405	0.7%
sites.google.com	236	0.4%
baidu	235	0.4%
google.com	199	0.4%
siliconvalley.about.com	151	0.3%
Other values (98)	1159	2.1%

Most occurring characters

Value	Count	Frequency (%)
e	54651	11.1%
o	54467	11.0%
c	47746	9.7%
t	46725	9.5%
u	34985	7.1%
r	29421	6.0%
i	29311	5.9%
d	28419	5.8%
(	27422	5.6%
)	27422	5.6%
Other values (25)	113141	22.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	417274	84.5%
Open Punctuation	27422	5.6%
Close Punctuation	27422	5.6%
Other Punctuation	20794	4.2%
Uppercase Letter	782	0.2%
Decimal Number	13	< 0.1%
Dash Punctuation	3	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	54651	13.1%
o	54467	13.1%
c	47746	11.4%
t	46725	11.2%
u	34985	8.4%
r	29421	7.1%
i	29311	7.0%
d	28419	6.8%
m	19465	4.7%
y	17992	4.3%
Other values (16)	54092	13.0%

Decimal Number

Value	Count	Frequency (%)
0	5	38.5%
2	5	38.5%
5	2	15.4%
3	1	7.7%

Open Punctuation

Value	Count	Frequency (%)
(	27422	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	27422	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	20794	100.0%

Uppercase Letter

Value	Count	Frequency (%)
P	782	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	418056	84.7%
Common	75654	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	54651	13.1%
o	54467	13.0%
c	47746	11.4%
t	46725	11.2%
u	34985	8.4%
r	29421	7.0%
i	29311	7.0%
d	28419	6.8%
m	19465	4.7%
y	17992	4.3%
Other values (17)	54874	13.1%

Common

Value	Count	Frequency (%)
(	27422	36.2%
)	27422	36.2%
.	20794	27.5%
0	5	< 0.1%
2	5	< 0.1%
-	3	< 0.1%
5	2	< 0.1%
3	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	493710	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	54651	11.1%
o	54467	11.0%
c	47746	9.7%
t	46725	9.5%
u	34985	7.1%
r	29421	6.0%
i	29311	5.9%
d	28419	5.8%
(	27422	5.6%
)	27422	5.6%
Other values (25)	113141	22.9%

trafficSource.medium
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

(none)	27422
referral	19330
organic	6980
affiliate	782
cpc	462

Length

Max length	9
Median length	8
Mean length	6.819504884
Min length	3

Characters and Unicode

Total characters	377671
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	organic
2nd row	organic
3rd row	organic
4th row	organic
5th row	organic

Common Values

Value	Count	Frequency (%)
(none)	27422	49.5%
referral	19330	34.9%
organic	6980	12.6%
affiliate	782	1.4%
cpc	462	0.8%
cpm	405	0.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
none	27422	49.5%
referral	19330	34.9%
organic	6980	12.6%
affiliate	782	1.4%
cpc	462	0.8%
cpm	405	0.7%

Most occurring characters

Value	Count	Frequency (%)
e	66864	17.7%
r	64970	17.2%
n	61824	16.4%
o	34402	9.1%
a	27874	7.4%
(	27422	7.3%
)	27422	7.3%
f	20894	5.5%
l	20112	5.3%
i	8544	2.3%
Other values (5)	17343	4.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	322827	85.5%
Open Punctuation	27422	7.3%
Close Punctuation	27422	7.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	66864	20.7%
r	64970	20.1%
n	61824	19.2%
o	34402	10.7%
a	27874	8.6%
f	20894	6.5%
l	20112	6.2%
i	8544	2.6%
c	8309	2.6%
g	6980	2.2%
Other values (3)	2054	0.6%

Open Punctuation

Value	Count	Frequency (%)
(	27422	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	27422	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	322827	85.5%
Common	54844	14.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	66864	20.7%
r	64970	20.1%
n	61824	19.2%
o	34402	10.7%
a	27874	8.6%
f	20894	6.5%
l	20112	6.2%
i	8544	2.6%
c	8309	2.6%
g	6980	2.2%
Other values (3)	2054	0.6%

Common

Value	Count	Frequency (%)
(	27422	50.0%
)	27422	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	377671	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	66864	17.7%
r	64970	17.2%
n	61824	16.4%
o	34402	9.1%
a	27874	7.4%
(	27422	7.3%
)	27422	7.3%
f	20894	5.5%
l	20112	5.3%
i	8544	2.3%
Other values (5)	17343	4.6%

trafficSource.isTrueDirect
Boolean

CONSTANT
HIGH CORRELATION
MISSING
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	38404
Missing (%)	69.3%
Memory size	432.8 KiB

True	16977
(Missing)	38404

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	16977	30.7%
(Missing)	38404	69.3%

device.browser
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

Chrome	38027
Safari	12182
Firefox	2028
Internet Explorer	1055
Edge	557
Other values (22)	1532

Length

Max length	24
Median length	6
Mean length	6.353189722
Min length	4

Characters and Unicode

Total characters	351846
Distinct characters	53
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	Chrome
2nd row	Chrome
3rd row	Chrome
4th row	Chrome
5th row	Chrome

Common Values

Value	Count	Frequency (%)
Chrome	38027	68.7%
Safari	12182	22.0%
Firefox	2028	3.7%
Internet Explorer	1055	1.9%
Edge	557	1.0%
Opera	360	0.7%
Safari (in-app)	308	0.6%
Opera Mini	277	0.5%
Android Webview	193	0.3%
YaBrowser	116	0.2%
Other values (17)	278	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chrome	38027	66.2%
safari	12490	21.7%
firefox	2028	3.5%
internet	1055	1.8%
explorer	1055	1.8%
opera	637	1.1%
edge	557	1.0%
in-app	308	0.5%
mini	277	0.5%
android	223	0.4%
Other values (23)	803	1.4%

Most occurring characters

Value	Count	Frequency (%)
r	57124	16.2%
e	45124	12.8%
o	41761	11.9%
C	38216	10.9%
m	38079	10.8%
h	38045	10.8%
a	26145	7.4%
i	15886	4.5%
f	14526	4.1%
S	12525	3.6%
Other values (43)	24415	6.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	291364	82.8%
Uppercase Letter	57467	16.3%
Space Separator	2079	0.6%
Open Punctuation	308	0.1%
Dash Punctuation	308	0.1%
Close Punctuation	308	0.1%
Decimal Number	9	< 0.1%
Connector Punctuation	3	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	57124	19.6%
e	45124	15.5%
o	41761	14.3%
m	38079	13.1%
h	38045	13.1%
a	26145	9.0%
i	15886	5.5%
f	14526	5.0%
x	3100	1.1%
n	3016	1.0%
Other values (14)	8558	2.9%

Uppercase Letter

Value	Count	Frequency (%)
C	38216	66.5%
S	12525	21.8%
F	2029	3.5%
E	1623	2.8%
I	1056	1.8%
O	648	1.1%
M	335	0.6%
B	288	0.5%
A	274	0.5%
W	193	0.3%
Other values (9)	280	0.5%

Decimal Number

Value	Count	Frequency (%)
0	4	44.4%
1	2	22.2%
5	1	11.1%
4	1	11.1%
2	1	11.1%

Space Separator

Value	Count	Frequency (%)
	2079	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	308	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	308	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	308	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	348831	99.1%
Common	3015	0.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	57124	16.4%
e	45124	12.9%
o	41761	12.0%
C	38216	11.0%
m	38079	10.9%
h	38045	10.9%
a	26145	7.5%
i	15886	4.6%
f	14526	4.2%
S	12525	3.6%
Other values (33)	21400	6.1%

Common

Value	Count	Frequency (%)
	2079	69.0%
(	308	10.2%
-	308	10.2%
)	308	10.2%
0	4	0.1%
_	3	0.1%
1	2	0.1%
5	1	< 0.1%
4	1	< 0.1%
2	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	351846	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	57124	16.2%
e	45124	12.8%
o	41761	11.9%
C	38216	10.9%
m	38079	10.8%
h	38045	10.8%
a	26145	7.4%
i	15886	4.5%
f	14526	4.1%
S	12525	3.6%
Other values (43)	24415	6.9%

device.operatingSystem
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

Windows	21174
Macintosh	19138
Android	5717
iOS	5049
Linux	2219
Other values (8)	2084

Length

Max length	13
Median length	12
Mean length	7.328560337
Min length	3

Characters and Unicode

Total characters	405863
Distinct characters	36
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Windows
2nd row	Android
3rd row	Windows
4th row	Android
5th row	iOS

Common Values

Value	Count	Frequency (%)
Windows	21174	38.2%
Macintosh	19138	34.6%
Android	5717	10.3%
iOS	5049	9.1%
Linux	2219	4.0%
Chrome OS	1733	3.1%
(not set)	215	0.4%
Windows Phone	92	0.2%
Samsung	12	< 0.1%
BlackBerry	12	< 0.1%
Other values (3)	20	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
windows	21266	37.0%
macintosh	19138	33.3%
android	5717	10.0%
ios	5049	8.8%
linux	2219	3.9%
os	1740	3.0%
chrome	1733	3.0%
not	215	0.4%
set	215	0.4%
phone	92	0.2%
Other values (6)	55	0.1%

Most occurring characters

Value	Count	Frequency (%)
i	53429	13.2%
n	48681	12.0%
o	48181	11.9%
s	40631	10.0%
d	32711	8.1%
W	21277	5.2%
w	21266	5.2%
h	20963	5.2%
t	19579	4.8%
a	19162	4.7%
Other values (26)	79983	19.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	339565	83.7%
Uppercase Letter	63810	15.7%
Space Separator	2058	0.5%
Open Punctuation	215	0.1%
Close Punctuation	215	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	53429	15.7%
n	48681	14.3%
o	48181	14.2%
s	40631	12.0%
d	32711	9.6%
w	21266	6.3%
h	20963	6.2%
t	19579	5.8%
a	19162	5.6%
c	19150	5.6%
Other values (11)	15812	4.7%

Uppercase Letter

Value	Count	Frequency (%)
W	21277	33.3%
M	19138	30.0%
S	6801	10.7%
O	6789	10.6%
A	5717	9.0%
L	2219	3.5%
C	1733	2.7%
P	92	0.1%
B	24	< 0.1%
N	11	< 0.1%
Other values (2)	9	< 0.1%

Space Separator

Value	Count	Frequency (%)
	2058	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	215	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	215	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	403375	99.4%
Common	2488	0.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	53429	13.2%
n	48681	12.1%
o	48181	11.9%
s	40631	10.1%
d	32711	8.1%
W	21277	5.3%
w	21266	5.3%
h	20963	5.2%
t	19579	4.9%
a	19162	4.8%
Other values (23)	77495	19.2%

Common

Value	Count	Frequency (%)
	2058	82.7%
(	215	8.6%
)	215	8.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	405863	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	53429	13.2%
n	48681	12.0%
o	48181	11.9%
s	40631	10.0%
d	32711	8.1%
W	21277	5.2%
w	21266	5.2%
h	20963	5.2%
t	19579	4.8%
a	19162	4.7%
Other values (26)	79983	19.7%

device.deviceCategory
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

desktop	44180
mobile	9658
tablet	1543

Length

Max length	7
Median length	7
Mean length	6.79774652
Min length	6

Characters and Unicode

Total characters	376466
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	desktop
2nd row	mobile
3rd row	desktop
4th row	mobile
5th row	mobile

Common Values

Value	Count	Frequency (%)
desktop	44180	79.8%
mobile	9658	17.4%
tablet	1543	2.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
desktop	44180	79.8%
mobile	9658	17.4%
tablet	1543	2.8%

Most occurring characters

Value	Count	Frequency (%)
e	55381	14.7%
o	53838	14.3%
t	47266	12.6%
d	44180	11.7%
s	44180	11.7%
k	44180	11.7%
p	44180	11.7%
b	11201	3.0%
l	11201	3.0%
m	9658	2.6%
Other values (2)	11201	3.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	376466	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	55381	14.7%
o	53838	14.3%
t	47266	12.6%
d	44180	11.7%
s	44180	11.7%
k	44180	11.7%
p	44180	11.7%
b	11201	3.0%
l	11201	3.0%
m	9658	2.6%
Other values (2)	11201	3.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	376466	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	55381	14.7%
o	53838	14.3%
t	47266	12.6%
d	44180	11.7%
s	44180	11.7%
k	44180	11.7%
p	44180	11.7%
b	11201	3.0%
l	11201	3.0%
m	9658	2.6%
Other values (2)	11201	3.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	376466	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	55381	14.7%
o	53838	14.3%
t	47266	12.6%
d	44180	11.7%
s	44180	11.7%
k	44180	11.7%
p	44180	11.7%
b	11201	3.0%
l	11201	3.0%
m	9658	2.6%
Other values (2)	11201	3.0%

hits.type
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

hits.hour
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

hits.minute
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	432.8 KiB

totals.bounces
Categorical

CONSTANT
HIGH CORRELATION
MISSING
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	30667
Missing (%)	55.4%
Memory size	432.8 KiB

1.0	24714

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	74142
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	24714	44.6%
(Missing)	30667	55.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
1.0	24714	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	24714	33.3%
.	24714	33.3%
0	24714	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	49428	66.7%
Other Punctuation	24714	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	24714	50.0%
0	24714	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	24714	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	74142	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	24714	33.3%
.	24714	33.3%
0	24714	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	74142	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	24714	33.3%
.	24714	33.3%
0	24714	33.3%

hits.eCommerceAction.action_type
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.01410230946

Minimum	0
Maximum	6
Zeros	55010
Zeros (%)	99.3%
Negative	0
Negative (%)	0.0%
Memory size	432.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	6
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.1966671608
Coefficient of variation (CV)	13.9457414
Kurtosis	326.7933552
Mean	0.01410230946
Median Absolute Deviation (MAD)	0
Skewness	16.95036344
Sum	781
Variance	0.03867797213
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	55010	99.3%
1	148	0.3%
2	103	0.2%
3	73	0.1%
4	29	0.1%
5	16	< 0.1%
6	2	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	55010	99.3%
1	148	0.3%
2	103	0.2%
3	73	0.1%
4	29	0.1%
5	16	< 0.1%
6	2	< 0.1%

Value	Count	Frequency (%)
6	2	< 0.1%
5	16	< 0.1%
4	29	0.1%
3	73	0.1%
2	103	0.2%
1	148	0.3%
0	55010	99.3%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	socialEngagementType	channelGrouping	date	fullVisitorId	totals.hits	totals.pageviews	totals.timeOnSite	totals.transactions	totals.newVisits	totals.totalTransactionRevenue	geoNetwork.country	trafficSource.source	trafficSource.medium	trafficSource.isTrueDirect	device.browser	device.operatingSystem	device.deviceCategory	hits.type	hits.hour	hits.minute	totals.bounces
0	Not Socially Engaged	Organic Search	20170101	8160804435292640144	1	1.0	NaN	NaN	1.0	NaN	Belarus	google	organic	NaN	Chrome	Windows	desktop	[PAGE]	[5]	[46]	1.0
1	Not Socially Engaged	Organic Search	20170101	2767232911658101391	1	1.0	NaN	NaN	1.0	NaN	Greece	google	organic	NaN	Chrome	Android	mobile	[PAGE]	[12]	[25]	1.0
2	Not Socially Engaged	Organic Search	20170101	5462105261493871939	1	1.0	NaN	NaN	1.0	NaN	Ireland	google	organic	NaN	Chrome	Windows	desktop	[PAGE]	[23]	[22]	1.0
3	Not Socially Engaged	Organic Search	20170101	95191702071842980	1	1.0	NaN	NaN	1.0	NaN	Indonesia	google	organic	NaN	Chrome	Android	mobile	[PAGE]	[5]	[21]	1.0
4	Not Socially Engaged	Organic Search	20170101	6692505544910101563	1	1.0	NaN	NaN	1.0	NaN	Australia	google	organic	NaN	Chrome	iOS	mobile	[PAGE]	[19]	[28]	1.0
5	Not Socially Engaged	Organic Search	20170101	2907946815222203879	1	1.0	NaN	NaN	1.0	NaN	Malaysia	google	organic	NaN	Chrome	Macintosh	desktop	[PAGE]	[0]	[33]	1.0
6	Not Socially Engaged	Direct	20170101	5652181055723415564	1	1.0	NaN	NaN	1.0	NaN	Netherlands	(direct)	(none)	True	Chrome	Linux	desktop	[PAGE]	[21]	[29]	1.0
7	Not Socially Engaged	Direct	20170101	7817519219547424500	1	1.0	NaN	NaN	1.0	NaN	United States	(direct)	(none)	True	Chrome	Android	mobile	[PAGE]	[5]	[17]	1.0
8	Not Socially Engaged	Organic Search	20170101	8362452234388944224	1	1.0	NaN	NaN	1.0	NaN	Netherlands	google	organic	NaN	Safari	iOS	tablet	[PAGE]	[11]	[21]	1.0
9	Not Socially Engaged	Paid Search	20170101	1309141223204608712	1	1.0	NaN	NaN	1.0	NaN	Saudi Arabia	google	cpc	NaN	Safari	iOS	mobile	[PAGE]	[6]	[43]	1.0

Last rows

	socialEngagementType	channelGrouping	date	fullVisitorId	totals.hits	totals.pageviews	totals.timeOnSite	totals.transactions	totals.newVisits	totals.totalTransactionRevenue	geoNetwork.country	trafficSource.source	trafficSource.medium	trafficSource.isTrueDirect	device.browser	device.operatingSystem	device.deviceCategory	hits.type	hits.hour	hits.minute	totals.bounces
55371	Not Socially Engaged	Referral	20161231	8461560860601581176	14	12.0	356.0	1.0	NaN	37180000.0	United States	(direct)	(none)	True	Chrome	Macintosh	desktop	[PAGE, EVENT, PAGE, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE]	[15, 15, 15, 15, 15, 15, 15, 15, 15, 15, 15, 15, 15, 15]	[1, 2, 2, 2, 2, 2, 2, 2, 3, 6, 6, 7, 7, 7]	NaN
55372	Not Socially Engaged	Organic Search	20161231	1323672990415209613	18	17.0	618.0	1.0	1.0	14990000.0	United States	(direct)	(none)	NaN	Chrome	Macintosh	desktop	[PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE]	[8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8, 8]	[14, 14, 14, 15, 16, 17, 17, 17, 18, 18, 18, 18, 18, 21, 22, 24, 24, 24]	NaN
55373	Not Socially Engaged	Organic Search	20161231	8224029032220919338	18	15.0	386.0	1.0	1.0	47980000.0	United States	(direct)	(none)	NaN	Safari	iOS	tablet	[PAGE, EVENT, PAGE, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE]	[9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9]	[52, 52, 52, 52, 52, 52, 53, 53, 53, 53, 54, 54, 54, 55, 55, 57, 58, 58]	NaN
55374	Not Socially Engaged	Referral	20161231	1875834855839567395	20	18.0	478.0	1.0	NaN	97030000.0	United States	(direct)	(none)	True	Chrome	Macintosh	desktop	[PAGE, PAGE, PAGE, PAGE, EVENT, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE]	[14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14, 14]	[41, 42, 43, 44, 44, 44, 44, 44, 45, 45, 46, 46, 46, 46, 47, 47, 48, 49, 49, 49]	NaN
55375	Not Socially Engaged	Organic Search	20161231	7400153334064056683	22	17.0	523.0	1.0	NaN	66980000.0	United States	(direct)	(none)	True	Chrome	Chrome OS	desktop	[PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, EVENT, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE]	[12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12, 12]	[14, 14, 14, 14, 14, 15, 17, 18, 19, 19, 19, 19, 20, 20, 20, 20, 20, 20, 21, 22, 23, 23]	NaN
55376	Not Socially Engaged	Direct	20161231	3391371207605838551	34	27.0	747.0	1.0	1.0	20590000.0	United States	(direct)	(none)	True	Chrome	Windows	desktop	[PAGE, PAGE, PAGE, PAGE, PAGE, EVENT, EVENT, EVENT, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE]	[19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19]	[21, 21, 21, 22, 22, 22, 23, 23, 23, 23, 23, 23, 23, 23, 24, 24, 24, 24, 25, 25, 26, 26, 26, 26, 27, 27, 27, 27, 31, 31, 31, 33, 33, 33]	NaN
55377	Not Socially Engaged	Referral	20161231	594032029140324639	36	32.0	937.0	1.0	NaN	36570000.0	United States	(direct)	(none)	True	Chrome	Macintosh	desktop	[PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, EVENT, EVENT, PAGE, PAGE, PAGE, EVENT, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE]	[7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7]	[41, 41, 43, 43, 44, 44, 45, 45, 45, 46, 46, 46, 46, 46, 46, 46, 46, 46, 46, 47, 47, 48, 48, 50, 50, 51, 52, 52, 52, 53, 54, 55, 55, 55, 56, 56]	NaN
55378	Not Socially Engaged	Referral	20161231	7616789203807782311	39	36.0	1349.0	1.0	1.0	87980000.0	United States	(direct)	(none)	NaN	Chrome	Macintosh	desktop	[PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, EVENT, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE]	[22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22, 22]	[11, 11, 12, 12, 13, 13, 14, 14, 18, 18, 18, 19, 19, 19, 19, 19, 19, 20, 20, 20, 21, 21, 24, 24, 24, 25, 25, 25, 26, 27, 28, 28, 29, 29, 30, 31, 33, 34, 34]	NaN
55379	Not Socially Engaged	Organic Search	20161231	2814253579769492109	39	30.0	1462.0	1.0	1.0	64990000.0	United States	(direct)	(none)	NaN	Chrome	Macintosh	desktop	[PAGE, PAGE, EVENT, EVENT, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE]	[10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10]	[19, 19, 19, 19, 19, 20, 20, 20, 20, 20, 20, 20, 20, 20, 23, 24, 24, 24, 24, 27, 28, 29, 29, 29, 30, 30, 30, 32, 32, 33, 33, 36, 37, 37, 37, 38, 42, 43, 43]	NaN
55380	Not Socially Engaged	Referral	20161231	6976057682793576646	72	50.0	1377.0	1.0	NaN	279880000.0	United States	(direct)	(none)	True	Chrome	Macintosh	desktop	[PAGE, PAGE, PAGE, PAGE, EVENT, EVENT, PAGE, PAGE, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, EVENT, PAGE, EVENT, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, EVENT, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE, PAGE]	[19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19, 19]	[23, 24, 24, 27, 27, 27, 27, 28, 28, 28, 28, 28, 28, 28, 29, 29, 29, 29, 29, 30, 30, 30, 30, 30, 30, 30, 31, 31, 31, 31, 32, 32, 32, 32, 33, 33, 33, 33, 35, 35, 35, 35, 35, 36, 36, 36, 36, 37, 37, 37, 37, 37, 37, 37, 37, 37, 38, 38, 40, 40, 41, 41, 41, 41, 42, 43, 44, 45, 45, 46, 46, 46]	NaN

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Final Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Open Punctuation

Close Punctuation

Other Punctuation